package com.ruoyi.mapper;

import com.ruoyi.domain.Score;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
@Mapper
public interface ScoreMapper {
    int addScore(Score score);
    Integer getScore(@Param("caseId")String caseId,@Param("positionId")Long positionId);

    Integer getSum(@Param("caseId")String caseId);

    List<Score> getScoreList(@Param("loadingId")String loadingId);


    Integer getSc(@Param("caseId")String caseId,@Param("positionId")Long positionId);

    Score scoreSum(@Param("caseId")String caseId,@Param("positionId")Long positionId);

    int updateDeleteCaseScore(@Param("caseId")String caseId);


    Integer getPosSum(@Param("loadingId")String loadingId);
}
